<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>StatisticDataFacade xref</title>
<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../apidocs/org/inftel/tms/statistics/StatisticDataFacade.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   <strong class="jxr_keyword">package</strong> org.inftel.tms.statistics;
<a class="jxr_linenumber" name="2" href="#2">2</a>   
<a class="jxr_linenumber" name="3" href="#3">3</a>   <strong class="jxr_keyword">import</strong> java.math.BigDecimal;
<a class="jxr_linenumber" name="4" href="#4">4</a>   <strong class="jxr_keyword">import</strong> java.util.Date;
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> java.util.HashMap;
<a class="jxr_linenumber" name="6" href="#6">6</a>   <strong class="jxr_keyword">import</strong> java.util.List;
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> java.util.Map;
<a class="jxr_linenumber" name="8" href="#8">8</a>   <strong class="jxr_keyword">import</strong> java.util.TreeMap;
<a class="jxr_linenumber" name="9" href="#9">9</a>   
<a class="jxr_linenumber" name="10" href="#10">10</a>  <strong class="jxr_keyword">import</strong> javax.ejb.Stateless;
<a class="jxr_linenumber" name="11" href="#11">11</a>  <strong class="jxr_keyword">import</strong> javax.persistence.EntityManager;
<a class="jxr_linenumber" name="12" href="#12">12</a>  <strong class="jxr_keyword">import</strong> javax.persistence.PersistenceContext;
<a class="jxr_linenumber" name="13" href="#13">13</a>  <strong class="jxr_keyword">import</strong> javax.persistence.TypedQuery;
<a class="jxr_linenumber" name="14" href="#14">14</a>  
<a class="jxr_linenumber" name="15" href="#15">15</a>  <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="16" href="#16">16</a>  <em class="jxr_javadoccomment"> * </em>
<a class="jxr_linenumber" name="17" href="#17">17</a>  <em class="jxr_javadoccomment"> * @author agumpg</em>
<a class="jxr_linenumber" name="18" href="#18">18</a>  <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="19" href="#19">19</a>  @Stateless
<a class="jxr_linenumber" name="20" href="#20">20</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/inftel/tms/statistics/StatisticDataFacade.html">StatisticDataFacade</a> <strong class="jxr_keyword">extends</strong> AbstractFacade&lt;StatisticDataEntity&gt; {
<a class="jxr_linenumber" name="21" href="#21">21</a>  
<a class="jxr_linenumber" name="22" href="#22">22</a>      @PersistenceContext(unitName = <span class="jxr_string">"tms-statistic-unit"</span>)
<a class="jxr_linenumber" name="23" href="#23">23</a>      <strong class="jxr_keyword">private</strong> EntityManager em;
<a class="jxr_linenumber" name="24" href="#24">24</a>  
<a class="jxr_linenumber" name="25" href="#25">25</a>      @Override
<a class="jxr_linenumber" name="26" href="#26">26</a>      <strong class="jxr_keyword">protected</strong> EntityManager getEntityManager() {
<a class="jxr_linenumber" name="27" href="#27">27</a>          <strong class="jxr_keyword">return</strong> em;
<a class="jxr_linenumber" name="28" href="#28">28</a>      }
<a class="jxr_linenumber" name="29" href="#29">29</a>  
<a class="jxr_linenumber" name="30" href="#30">30</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../org/inftel/tms/statistics/StatisticDataFacade.html">StatisticDataFacade</a>() {
<a class="jxr_linenumber" name="31" href="#31">31</a>          <strong class="jxr_keyword">super</strong>(StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="32" href="#32">32</a>      }
<a class="jxr_linenumber" name="33" href="#33">33</a>  
<a class="jxr_linenumber" name="34" href="#34">34</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="35" href="#35">35</a>  <em class="jxr_javadoccomment">     * Suma las estadísticas diarias, mensuales o anuales de un determinado valor entre un rango de</em>
<a class="jxr_linenumber" name="36" href="#36">36</a>  <em class="jxr_javadoccomment">     * fechas</em>
<a class="jxr_linenumber" name="37" href="#37">37</a>  <em class="jxr_javadoccomment">     * </em>
<a class="jxr_linenumber" name="38" href="#38">38</a>  <em class="jxr_javadoccomment">     * @param startWith</em>
<a class="jxr_linenumber" name="39" href="#39">39</a>  <em class="jxr_javadoccomment">     *            nombre del atributo estadístico</em>
<a class="jxr_linenumber" name="40" href="#40">40</a>  <em class="jxr_javadoccomment">     * @param period</em>
<a class="jxr_linenumber" name="41" href="#41">41</a>  <em class="jxr_javadoccomment">     *            diario, mensual o anual</em>
<a class="jxr_linenumber" name="42" href="#42">42</a>  <em class="jxr_javadoccomment">     * @param fromDate</em>
<a class="jxr_linenumber" name="43" href="#43">43</a>  <em class="jxr_javadoccomment">     *            fecha de inicio del sumatorio</em>
<a class="jxr_linenumber" name="44" href="#44">44</a>  <em class="jxr_javadoccomment">     * @param toDate</em>
<a class="jxr_linenumber" name="45" href="#45">45</a>  <em class="jxr_javadoccomment">     *            fecha fin del sumatorio</em>
<a class="jxr_linenumber" name="46" href="#46">46</a>  <em class="jxr_javadoccomment">     * @return sumatorio de los estadísticos</em>
<a class="jxr_linenumber" name="47" href="#47">47</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="48" href="#48">48</a>      <strong class="jxr_keyword">public</strong> Map&lt;String, BigDecimal&gt; sumStatictics(String startWith, <a href="../../../../org/inftel/tms/statistics/StatisticDataPeriod.html">StatisticDataPeriod</a> period,
<a class="jxr_linenumber" name="49" href="#49">49</a>              Date fromDate, Date toDate) {
<a class="jxr_linenumber" name="50" href="#50">50</a>          TypedQuery&lt;StatisticDataEntity&gt; query = em.createQuery(<span class="jxr_string">"SELECT o FROM StatisticDataEntity o "</span>
<a class="jxr_linenumber" name="51" href="#51">51</a>                  + <span class="jxr_string">"WHERE o.name LIKE :name AND o.periodType = :period "</span>
<a class="jxr_linenumber" name="52" href="#52">52</a>                  + <span class="jxr_string">"AND o.periodDate BETWEEN :fromDate AND :toDate"</span>, StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="53" href="#53">53</a>          query.setParameter(<span class="jxr_string">"name"</span>, startWith + <span class="jxr_string">"%"</span>);
<a class="jxr_linenumber" name="54" href="#54">54</a>          query.setParameter(<span class="jxr_string">"period"</span>, period);
<a class="jxr_linenumber" name="55" href="#55">55</a>          query.setParameter(<span class="jxr_string">"fromDate"</span>, fromDate);
<a class="jxr_linenumber" name="56" href="#56">56</a>          query.setParameter(<span class="jxr_string">"toDate"</span>, toDate);
<a class="jxr_linenumber" name="57" href="#57">57</a>  
<a class="jxr_linenumber" name="58" href="#58">58</a>          List&lt;StatisticDataEntity&gt; queryResult = query.getResultList();
<a class="jxr_linenumber" name="59" href="#59">59</a>          Map&lt;String, BigDecimal&gt; result = <strong class="jxr_keyword">new</strong> HashMap&lt;String, BigDecimal&gt;(2);
<a class="jxr_linenumber" name="60" href="#60">60</a>          <em class="jxr_comment">// Initialize result</em>
<a class="jxr_linenumber" name="61" href="#61">61</a>          result.put(<span class="jxr_string">"sum"</span>, <strong class="jxr_keyword">new</strong> BigDecimal(0));
<a class="jxr_linenumber" name="62" href="#62">62</a>          result.put(<span class="jxr_string">"count"</span>, <strong class="jxr_keyword">new</strong> BigDecimal(0));
<a class="jxr_linenumber" name="63" href="#63">63</a>          <strong class="jxr_keyword">for</strong> (StatisticDataEntity data : queryResult) {
<a class="jxr_linenumber" name="64" href="#64">64</a>              <strong class="jxr_keyword">if</strong> (data.getDataSum() != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="65" href="#65">65</a>                  result.put(<span class="jxr_string">"sum"</span>, result.get(<span class="jxr_string">"sum"</span>).add(<strong class="jxr_keyword">new</strong> BigDecimal(data.getDataSum())));
<a class="jxr_linenumber" name="66" href="#66">66</a>              }
<a class="jxr_linenumber" name="67" href="#67">67</a>              <strong class="jxr_keyword">if</strong> (data.getDataCount() != <strong class="jxr_keyword">null</strong>) {
<a class="jxr_linenumber" name="68" href="#68">68</a>                  result.put(<span class="jxr_string">"count"</span>, result.get(<span class="jxr_string">"count"</span>).add(<strong class="jxr_keyword">new</strong> BigDecimal(data.getDataCount())));
<a class="jxr_linenumber" name="69" href="#69">69</a>              }
<a class="jxr_linenumber" name="70" href="#70">70</a>          }
<a class="jxr_linenumber" name="71" href="#71">71</a>          <strong class="jxr_keyword">return</strong> result;
<a class="jxr_linenumber" name="72" href="#72">72</a>      }
<a class="jxr_linenumber" name="73" href="#73">73</a>  
<a class="jxr_linenumber" name="74" href="#74">74</a>      <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="75" href="#75">75</a>  <em class="jxr_javadoccomment">     * Busca todos los valores estadisticos que comiencen con el nombre pasado como parametro.</em>
<a class="jxr_linenumber" name="76" href="#76">76</a>  <em class="jxr_javadoccomment">     * </em>
<a class="jxr_linenumber" name="77" href="#77">77</a>  <em class="jxr_javadoccomment">     * @param startWith</em>
<a class="jxr_linenumber" name="78" href="#78">78</a>  <em class="jxr_javadoccomment">     *            nombre estadistico que filtra los tipos que se quieren obtener</em>
<a class="jxr_linenumber" name="79" href="#79">79</a>  <em class="jxr_javadoccomment">     * @param period</em>
<a class="jxr_linenumber" name="80" href="#80">80</a>  <em class="jxr_javadoccomment">     *            periodo estadistico que se quiere obtener</em>
<a class="jxr_linenumber" name="81" href="#81">81</a>  <em class="jxr_javadoccomment">     * @param date</em>
<a class="jxr_linenumber" name="82" href="#82">82</a>  <em class="jxr_javadoccomment">     *            fecha del periodo que se quiere obtener</em>
<a class="jxr_linenumber" name="83" href="#83">83</a>  <em class="jxr_javadoccomment">     * @return parejas de nombre de estadistica y valor para el periodo y facha pasados</em>
<a class="jxr_linenumber" name="84" href="#84">84</a>  <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="85" href="#85">85</a>      <strong class="jxr_keyword">public</strong> Map&lt;String, Long&gt; findStatistics(String startWith, <a href="../../../../org/inftel/tms/statistics/StatisticDataPeriod.html">StatisticDataPeriod</a> period, Date date) {
<a class="jxr_linenumber" name="86" href="#86">86</a>          TypedQuery&lt;StatisticDataEntity&gt; query = em.createQuery(<span class="jxr_string">"SELECT o FROM StatisticData o "</span>
<a class="jxr_linenumber" name="87" href="#87">87</a>                  + <span class="jxr_string">"WHERE o.name LIKE :name AND o.periodType = :period AND o.periodDate = :date"</span>,
<a class="jxr_linenumber" name="88" href="#88">88</a>                  StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="89" href="#89">89</a>          query.setParameter(<span class="jxr_string">"name"</span>, startWith + <span class="jxr_string">"%"</span>);
<a class="jxr_linenumber" name="90" href="#90">90</a>          query.setParameter(<span class="jxr_string">"period"</span>, period);
<a class="jxr_linenumber" name="91" href="#91">91</a>          query.setParameter(<span class="jxr_string">"date"</span>, date);
<a class="jxr_linenumber" name="92" href="#92">92</a>          Map&lt;String, Long&gt; result = <strong class="jxr_keyword">new</strong> TreeMap&lt;String, Long&gt;();
<a class="jxr_linenumber" name="93" href="#93">93</a>          <strong class="jxr_keyword">for</strong> (StatisticDataEntity data : query.getResultList()) {
<a class="jxr_linenumber" name="94" href="#94">94</a>              <em class="jxr_comment">// FIXME deberia devolverse BigDecimal</em>
<a class="jxr_linenumber" name="95" href="#95">95</a>              result.put(data.getName(), data.getDataValue().longValue());
<a class="jxr_linenumber" name="96" href="#96">96</a>          }
<a class="jxr_linenumber" name="97" href="#97">97</a>          <strong class="jxr_keyword">return</strong> result;
<a class="jxr_linenumber" name="98" href="#98">98</a>      }
<a class="jxr_linenumber" name="99" href="#99">99</a>  
<a class="jxr_linenumber" name="100" href="#100">100</a>     <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="101" href="#101">101</a> <em class="jxr_javadoccomment">     * Busca el intervalo de datos estadisticos para los nombres de estadisticas que comiencen con</em>
<a class="jxr_linenumber" name="102" href="#102">102</a> <em class="jxr_javadoccomment">     * el nombre pasado como parametro en un rango de fechas.</em>
<a class="jxr_linenumber" name="103" href="#103">103</a> <em class="jxr_javadoccomment">     * </em>
<a class="jxr_linenumber" name="104" href="#104">104</a> <em class="jxr_javadoccomment">     * Para facilitar las busquedas, este metodo filtra las fechas pasadas para ajustarlas al</em>
<a class="jxr_linenumber" name="105" href="#105">105</a> <em class="jxr_javadoccomment">     * periodo, de esta forma si por ejemplo se pide periodo anual, y la fecha es desde el 3 enero</em>
<a class="jxr_linenumber" name="106" href="#106">106</a> <em class="jxr_javadoccomment">     * 2011 hasta 7 marzo del 2011, se devolvera la muestra anual del 2011.</em>
<a class="jxr_linenumber" name="107" href="#107">107</a> <em class="jxr_javadoccomment">     * </em>
<a class="jxr_linenumber" name="108" href="#108">108</a> <em class="jxr_javadoccomment">     * @param name</em>
<a class="jxr_linenumber" name="109" href="#109">109</a> <em class="jxr_javadoccomment">     *            nombre del estadistico que se quieren obtener (i.e. alert.type.user)</em>
<a class="jxr_linenumber" name="110" href="#110">110</a> <em class="jxr_javadoccomment">     * @param period</em>
<a class="jxr_linenumber" name="111" href="#111">111</a> <em class="jxr_javadoccomment">     *            periodo estadistico que se quiere obtener [DAILY|MOUNTHLY|ANNUAL]</em>
<a class="jxr_linenumber" name="112" href="#112">112</a> <em class="jxr_javadoccomment">     * @param fromDate</em>
<a class="jxr_linenumber" name="113" href="#113">113</a> <em class="jxr_javadoccomment">     *            inicio de intervalo</em>
<a class="jxr_linenumber" name="114" href="#114">114</a> <em class="jxr_javadoccomment">     * @param toDate</em>
<a class="jxr_linenumber" name="115" href="#115">115</a> <em class="jxr_javadoccomment">     *            fin de intervalo</em>
<a class="jxr_linenumber" name="116" href="#116">116</a> <em class="jxr_javadoccomment">     * @return</em>
<a class="jxr_linenumber" name="117" href="#117">117</a> <em class="jxr_javadoccomment">     */</em>
<a class="jxr_linenumber" name="118" href="#118">118</a>     <strong class="jxr_keyword">public</strong> Map&lt;Date, StatisticData&gt; findStatistics(String name, <a href="../../../../org/inftel/tms/statistics/StatisticDataPeriod.html">StatisticDataPeriod</a> period, Date fromDate,
<a class="jxr_linenumber" name="119" href="#119">119</a>             Date toDate) {
<a class="jxr_linenumber" name="120" href="#120">120</a>         fromDate = period.beginsAt(fromDate);
<a class="jxr_linenumber" name="121" href="#121">121</a>         toDate = period.endsAt(toDate);
<a class="jxr_linenumber" name="122" href="#122">122</a> 
<a class="jxr_linenumber" name="123" href="#123">123</a>         TypedQuery&lt;StatisticDataEntity&gt; query = em.createQuery(<span class="jxr_string">"SELECT o "</span>
<a class="jxr_linenumber" name="124" href="#124">124</a>                 + <span class="jxr_string">"FROM StatisticData o WHERE o.name = :name AND o.periodType = :period "</span>
<a class="jxr_linenumber" name="125" href="#125">125</a>                 + <span class="jxr_string">"AND o.periodDate "</span> + <span class="jxr_string">"BETWEEN :fromDate AND :toDate"</span>, StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="126" href="#126">126</a>         query.setParameter(<span class="jxr_string">"name"</span>, name);
<a class="jxr_linenumber" name="127" href="#127">127</a>         query.setParameter(<span class="jxr_string">"period"</span>, period);
<a class="jxr_linenumber" name="128" href="#128">128</a>         query.setParameter(<span class="jxr_string">"fromDate"</span>, fromDate);
<a class="jxr_linenumber" name="129" href="#129">129</a>         query.setParameter(<span class="jxr_string">"toDate"</span>, toDate);
<a class="jxr_linenumber" name="130" href="#130">130</a> 
<a class="jxr_linenumber" name="131" href="#131">131</a>         Map&lt;Date, StatisticData&gt; result = <strong class="jxr_keyword">new</strong> TreeMap&lt;Date, StatisticData&gt;();
<a class="jxr_linenumber" name="132" href="#132">132</a>         <strong class="jxr_keyword">for</strong> (StatisticDataEntity data : query.getResultList()) {
<a class="jxr_linenumber" name="133" href="#133">133</a>             result.put(data.getPeriodDate(), data);
<a class="jxr_linenumber" name="134" href="#134">134</a>         }
<a class="jxr_linenumber" name="135" href="#135">135</a>         <strong class="jxr_keyword">return</strong> result;
<a class="jxr_linenumber" name="136" href="#136">136</a>     }
<a class="jxr_linenumber" name="137" href="#137">137</a> 
<a class="jxr_linenumber" name="138" href="#138">138</a>     <strong class="jxr_keyword">public</strong> <a href="../../../../org/inftel/tms/statistics/StatisticDataEntity.html">StatisticDataEntity</a> findByDate(String startWith, Date date) {
<a class="jxr_linenumber" name="139" href="#139">139</a>         TypedQuery&lt;StatisticDataEntity&gt; query = em.createQuery(<span class="jxr_string">"SELECT o FROM StatisticDataEntity o "</span>
<a class="jxr_linenumber" name="140" href="#140">140</a>                 + <span class="jxr_string">"WHERE o.name LIKE :name AND o.periodDate = :date"</span>, StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="141" href="#141">141</a>         query.setParameter(<span class="jxr_string">"name"</span>, startWith + <span class="jxr_string">"%"</span>);
<a class="jxr_linenumber" name="142" href="#142">142</a>         query.setParameter(<span class="jxr_string">"date"</span>, date);
<a class="jxr_linenumber" name="143" href="#143">143</a>         query.setMaxResults(1); <em class="jxr_comment">// aunq el modelo no debe devolver mas de uno</em>
<a class="jxr_linenumber" name="144" href="#144">144</a> 
<a class="jxr_linenumber" name="145" href="#145">145</a>         List&lt;StatisticDataEntity&gt; result = query.getResultList();
<a class="jxr_linenumber" name="146" href="#146">146</a>         <strong class="jxr_keyword">return</strong> (result.size() &gt; 0) ? result.get(0) : <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="147" href="#147">147</a>     }
<a class="jxr_linenumber" name="148" href="#148">148</a> 
<a class="jxr_linenumber" name="149" href="#149">149</a>     <strong class="jxr_keyword">public</strong> List&lt;String&gt; findStatisticsNames(String startWith) {
<a class="jxr_linenumber" name="150" href="#150">150</a>         TypedQuery&lt;String&gt; query = em.createQuery(<span class="jxr_string">"SELECT DISTINCT o.name "</span>
<a class="jxr_linenumber" name="151" href="#151">151</a>                 + <span class="jxr_string">"FROM StatisticData o WHERE o.name LIKE :name"</span>, String.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="152" href="#152">152</a>         <strong class="jxr_keyword">return</strong> query.setParameter(<span class="jxr_string">"name"</span>, startWith + <span class="jxr_string">"%"</span>).getResultList();
<a class="jxr_linenumber" name="153" href="#153">153</a>     }
<a class="jxr_linenumber" name="154" href="#154">154</a> 
<a class="jxr_linenumber" name="155" href="#155">155</a>     <a href="../../../../org/inftel/tms/statistics/StatisticDataFacade.html">StatisticDataFacade</a>(EntityManager em) {
<a class="jxr_linenumber" name="156" href="#156">156</a>         <strong class="jxr_keyword">super</strong>(StatisticDataEntity.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="157" href="#157">157</a>         <strong class="jxr_keyword">this</strong>.em = em;
<a class="jxr_linenumber" name="158" href="#158">158</a>     }
<a class="jxr_linenumber" name="159" href="#159">159</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

